[H2 and Firebird]auto_increment, identity or trigger plus generator?
Posted
by blow
on Stack Overflow
See other posts from Stack Overflow
or by blow
Published on 2010-05-03T17:02:27Z
Indexed on
2010/05/03
17:08 UTC
Read the original article
Hit count: 226
Hi all, in Firebird the only way to have an auto increment coloumn is to setup a generator and use it with a trigger.
In H2 db there are auto_increment and identity keywords to do it.
What is the best way?
Mysql use auto_increment too, but there is some problems with cuncurrence read and table lock, isn't true?
Thank you.
© Stack Overflow or respective owner
